﻿<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="CreateEmployee.aspx.vb" Inherits="TWIN_test.CreateEmployee" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body background="../Images/Training-Administrator-Background.gif">
    <form id="form1" runat="server">
    <center><div style="height: 395px">
           Create Employee Profile<br />
            Email Address   :<asp:TextBox id="userEmailBox" runat="server" 
                ReadOnly="False" /><br />
            User Name :<asp:TextBox id="createUserNameBox" runat="server" 
                ReadOnly="False" /><br />
             Password        :<asp:TextBox id="createUserPasswordBox" TextMode="password" 
                runat="server" ReadOnly="False" />  Min Characters = 4 | 1 Non-alphanumeric 
         <br /> 

             First Name      :<asp:TextBox id="userFirstNameBox" 
                runat="server" ReadOnly="False" /><br />
             Last Name       :<asp:TextBox id="userLastNameBox" 
                runat="server" ReadOnly="False" /><br /> 
             Street          :<asp:TextBox id="userStreetBox" 
                runat="server" ReadOnly="False" /><br />
             City            :<asp:TextBox id="userCityBox" runat="server" 
                ReadOnly="False" /><br />
             State           :<asp:TextBox id="userStateBox" runat="server" 
                ReadOnly="False" /><br /> 
             ZIP             :<asp:TextBox id="userZipBox" runat="server" ReadOnly="False" /><br /> 
             Department      :<asp:TextBox id="userDepartmentBox" 
                runat="server" ReadOnly="False" /><br /><br />

            
            
             <br />
           <br />
             <asp:Button id="createButton" runat="server" text="Save and Create Employee" /> 
            

            <asp:Button ID="backButton" runat="server" Text="Back" />
            

           <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
               ConnectionString="<%$ ConnectionStrings:ConnectionString2 %>" DeleteCommand="z" 
               InsertCommand="INSERT INTO INFO(USERID, STREETADDRESS, CITY, STATE, ZIPCODE) VALUES (utl_raw.cast_to_raw(:userid),:streetAddress,:city,:state,:zipcode)" 
               ProviderName="<%$ ConnectionStrings:ConnectionString2.ProviderName %>" 
               SelectCommand="z" UpdateCommand="z">
               
               <insertparameters>
           
              <asp:controlparameter name="streetAddress" controlid="userStreetBox" propertyname="Text"/>
              <asp:controlparameter name="city" controlid="userCityBox" propertyname="Text"/>
              <asp:controlparameter name="state" controlid="userStateBox" propertyname="Text"/>
              <asp:controlparameter name="zipCode" controlid="userZipBox" propertyname="Text"/>
          </insertparameters>
               
               </asp:SqlDataSource>
        <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
               </div> </center>
    </form>
</body>
</html>
